

INSERT INTO PRODUCT_PRODUCT
(
    ID
  , CATALOG_ID
  , MAIN_PHOTO_ID
  , TEMPLATE_ID
  , REGION_CODE
  , WAREHOUSE_CODE
  , ITEM_NUMBER
  , ITEM_SKU
  , STOCK_ITEM_NUMBER
  , SHORT_DESC
  , FULL_DESC
  , SHORT_DESC_EN
  , FULL_DESC_EN
  , PRE_ORIGINAL_PRICE
  , PRE_DISCOUNT_PRICE
  , PRE_PRICE1
  , PRE_PRICE2
  , PRE_NATION_TAX
  , PRE_LOCATION_TAX
  , PRE_CURRENCY_CODE
  , PRE_SALABLE_STATUS
  , UNTIL_DATE_TIME
  , POST_ORIGINAL_PRICE
  , POST_DISCOUNT_PRICE
  , POST_PRICE1
  , POST_PRICE2
  , POST_NATION_TAX
  , POST_LOCATION_TAX
  , POST_CURRENCY_CODE
  , POST_SALABLE_STATUS
  , UNIT_CODE
  , RETURN_TYPE
  , STATUS_
  , KEYING_FLAG
  , STOCK_CONTROL_FLAG
  , COUNT_FLAG
  , ITEM_SOURCE_TYPE
  , PROMOTION_FLAG
  , DISCOUNT_TYPE
  , PACKAGE_FLAG
  , ITEM_STATUS_TABLE_FLAG
  , BIZ_FLAG
  , ADVANCED_FLAG
  , PERCENTAGE_LIST
  , TRANSFER_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select
    product_product_id_seq.nextval   ID                                                                  
  , NULL              CATALOG_ID                   
  , NULL              MAIN_PHOTO_ID                
  , NULL              TEMPLATE_ID                  
  , 360               REGION_CODE                  
  , '0000'            WAREHOUSE_CODE               
  , 12345             ITEM_NUMBER                  
  , ' 12345CH  '      ITEM_SKU                     
  , 12345             STOCK_ITEM_NUMBER            
  , '伊姿大笔刨'      SHORT_DESC                   
  , '伊姿大笔刨'      FULL_DESC                    
  , NULL              SHORT_DESC_EN                
  , NULL              FULL_DESC_EN                 
  , 30                PRE_ORIGINAL_PRICE           
  , 30                PRE_DISCOUNT_PRICE           
  , 0                 PRE_PRICE1                   
  , 0                 PRE_PRICE2                   
  , 0                 PRE_NATION_TAX               
  , 0                 PRE_LOCATION_TAX             
  , 'CNY'             PRE_CURRENCY_CODE            
  , 0                 PRE_SALABLE_STATUS           
  , 20110905000000    UNTIL_DATE_TIME              
  , 30                POST_ORIGINAL_PRICE          
  , 30                POST_DISCOUNT_PRICE          
  , 0                 POST_PRICE1                  
  , 0                 POST_PRICE2                  
  , 0                 POST_NATION_TAX              
  , 0                 POST_LOCATION_TAX            
  , 'CNY'             POST_CURRENCY_CODE           
  , 1               POST_SALABLE_STATUS          
  , 'E'               UNIT_CODE                    
  , 'Y'               RETURN_TYPE                  
  , 1                 STATUS_                      
  , 1                 KEYING_FLAG                  
  , 1                 STOCK_CONTROL_FLAG           
  , 1                 COUNT_FLAG                   
  , 0                 ITEM_SOURCE_TYPE             
  , 9                 PROMOTION_FLAG               
  , 'P'               DISCOUNT_TYPE                
  , 0                 PACKAGE_FLAG                 
  , 0                 ITEM_STATUS_TABLE_FLAG       
  , 0                 BIZ_FLAG                     
  , 0                 ADVANCED_FLAG                
  , '100/75'          PERCENTAGE_LIST              
  , NULL              TRANSFER_STATUS              
  , current_timestamp CREATED_TIMESTAMP            
  , current_timestamp MODIFIED_TIMESTAMP           
from dual;



INSERT INTO PRODUCT_PRODUCT
(
    ID
  , CATALOG_ID
  , MAIN_PHOTO_ID
  , TEMPLATE_ID
  , REGION_CODE
  , WAREHOUSE_CODE
  , ITEM_NUMBER
  , ITEM_SKU
  , STOCK_ITEM_NUMBER
  , SHORT_DESC
  , FULL_DESC
  , SHORT_DESC_EN
  , FULL_DESC_EN
  , PRE_ORIGINAL_PRICE
  , PRE_DISCOUNT_PRICE
  , PRE_PRICE1
  , PRE_PRICE2
  , PRE_NATION_TAX
  , PRE_LOCATION_TAX
  , PRE_CURRENCY_CODE
  , PRE_SALABLE_STATUS
  , UNTIL_DATE_TIME
  , POST_ORIGINAL_PRICE
  , POST_DISCOUNT_PRICE
  , POST_PRICE1
  , POST_PRICE2
  , POST_NATION_TAX
  , POST_LOCATION_TAX
  , POST_CURRENCY_CODE
  , POST_SALABLE_STATUS
  , UNIT_CODE
  , RETURN_TYPE
  , STATUS_
  , KEYING_FLAG
  , STOCK_CONTROL_FLAG
  , COUNT_FLAG
  , ITEM_SOURCE_TYPE
  , PROMOTION_FLAG
  , DISCOUNT_TYPE
  , PACKAGE_FLAG
  , ITEM_STATUS_TABLE_FLAG
  , BIZ_FLAG
  , ADVANCED_FLAG
  , PERCENTAGE_LIST
  , TRANSFER_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select
    product_product_id_seq.nextval   ID                                                                  
  , NULL              CATALOG_ID                   
  , NULL              MAIN_PHOTO_ID                
  , NULL              TEMPLATE_ID                  
  , 360               REGION_CODE                  
  , '0000'            WAREHOUSE_CODE               
  , 23456             ITEM_NUMBER                  
  , ' 23456CH  '      ITEM_SKU                     
  , 23456             STOCK_ITEM_NUMBER            
  , '伊姿大笔刨'      SHORT_DESC                   
  , '伊姿大笔刨'      FULL_DESC                    
  , NULL              SHORT_DESC_EN                
  , NULL              FULL_DESC_EN                 
  , 30                PRE_ORIGINAL_PRICE           
  , 30                PRE_DISCOUNT_PRICE           
  , 0                 PRE_PRICE1                   
  , 0                 PRE_PRICE2                   
  , 0                 PRE_NATION_TAX               
  , 0                 PRE_LOCATION_TAX             
  , 'CNY'             PRE_CURRENCY_CODE            
  , 0                 PRE_SALABLE_STATUS           
  , 20110905000000    UNTIL_DATE_TIME              
  , 40                POST_ORIGINAL_PRICE          
  , 40                POST_DISCOUNT_PRICE          
  , 0                 POST_PRICE1                  
  , 0                 POST_PRICE2                  
  , 0                 POST_NATION_TAX              
  , 0                 POST_LOCATION_TAX            
  , 'CNY'             POST_CURRENCY_CODE           
  , 1                 POST_SALABLE_STATUS          
  , 'E'               UNIT_CODE                    
  , 'Y'               RETURN_TYPE                  
  , 1                 STATUS_                      
  , 0                 KEYING_FLAG                  
  , 1                 STOCK_CONTROL_FLAG           
  , 1                 COUNT_FLAG                   
  , 0                 ITEM_SOURCE_TYPE             
  , 9                 PROMOTION_FLAG               
  , 7                 DISCOUNT_TYPE                
  , 0                 PACKAGE_FLAG                 
  , 0                 ITEM_STATUS_TABLE_FLAG       
  , 0                 BIZ_FLAG                     
  , 0                 ADVANCED_FLAG                
  , '100/75'          PERCENTAGE_LIST              
  , NULL              TRANSFER_STATUS              
  , current_timestamp CREATED_TIMESTAMP            
  , current_timestamp MODIFIED_TIMESTAMP           
from dual;

